Translate into your language!

Export as Delimited Text File

Overview

This function lets you export data from Lotto Sorcerer into a delimited text file. This is useful for backing up data, importing the data into an SQL database, as well as sharing data with another user of Lotto Sorcerer. The file you export can be easily imported back into the program.

Please note that unregistered versions of Lotto Sorcerer are limited to 50 records for exporting.

How to Invoke

Use the menu item "Lottery Data > Export Lottery Data > Export as Delimited Text File...".

Basic Procedure

Window Controls

"Select Lottery" dropdown

Choose the lottery you want to export.

"Date Format" dropdown

Choose the exact date format you want to use.

Four Digit Years checkbox

If checked, the data will be exported as four-digit years (for example, '2005'); if unchecked only the last two digits are exported (for example, '2005' will be exported as '05'). Note that if you choose "[nothing]" as the character between Date Elements, this checkbox will be checked automatically.

Two Digit Years Month, Day

If checked, the data will be exported as two-digit months and days (for example, '01/09/2013'); if unchecked, these values will have only one digit (for example, '1/9/2013'). Note that if you choose "[nothing]" as the character between Date Elements, this checkbox will be checked automatically.

"Character Between Date Elements" dropdown

Choose the character that separates the year, month and day parts in the date field.

"Character Between Date and Numbers" dropdown

Choose the character that separates the date field and the number fields.

"Character Between Numbers" dropdown

Choose the character that separates the different number fields.

Two Digit Numbers

If checked, single digit numbers will be zero padded. For example, '1-2-5-16-19' will be exported as '01-02-05-16-19'. If you chose "[nothing] as the character between numbers, this will be checked automatically.

"End-of-Line Terminator" dropdown

Different operating systems use different characters to mark the end of line. Choose the appropriate one.